Rollback

The RollbackRun can be executed, to revert the database changes that are partially applied for Initial / Subsequent / Alias Run. When Rollback Run is executed the changes that are applied partially in the Target database will be reverted back, based on the current state of the Target database with reference to the previous Run snapshot.

Steps to Execute Rollback Run

Step 1: When Initial / Subsequent / Alias Run is executed partially in the Target database, the Run status will be displayed as "ChangesPartiallyApplied" on the Run screen with a Rollback icon displayed in Action column of the Run record.

 Rollback Run Option

Step 2: Click Rollback icon. A Rollback run is created with Rollback Run GUID. The Run status will be displayed as ChangeLogStarted on the Run screen.

 Rollback Applied

Step 3: Click Refresh. The Run status will be displayed as ChangeLogComplete on the Run screen.

Rollback ChangeLogComplete

Note: Keep clicking the Refreshto get the latest execution status displayed on the Run screen.

         The Action Column of the table displays the below action icons. When the row expander button of the Subsequent Run record is clicked, the Subsequent Run details are displayed. The Action Column of the table displays the action icons.

Preview

When Preview is clicked, shows the Target DDL and Staging DDL scripts generated under its respective links.

Execute:

  1. Click Execute.
  1. Enter Target, Staging Database Username and Passworddetails and click Execute. The scripts that are generated to revert the applied changes will be executed on the Target and Staging databases. The Rollback Run status is updated as Complete in the Run Screen. The Run status for the Rolled back run (Initial / Subsequent / Alias ) will be updated as "Reverted".

          RollbackComplete

Note: Keep clicking the Refreshto get the latest execution status displayed on the Run screen.

Download:

When Download is clicked, the Target & Staging DDLs will be downloaded in a (.zip) file, which the user can execute manually to apply the scripts to the Target and Staging databases.

Discard:

When Discard is clicked, the Rollback run execution changes are discarded and the Run status will be updated as Discarded.

In case Run execution fails, Run status will be updated as ExecutionFailed

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us